<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_store_adminer`;");
E_C("CREATE TABLE `ecs_store_adminer` (
  `rec_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` smallint(5) unsigned NOT NULL,
  `admin_name` varchar(255) NOT NULL,
  `store_id` smallint(5) unsigned NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '入驻商店铺id',
  `store_type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '仓库类型id',
  PRIMARY KEY (`rec_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='仓库（或库房）管理员'");
E_D("replace into `ecs_store_adminer` values('12','4','沈阳库库管','3','18712345678','03350785268','0','0');");
E_D("replace into `ecs_store_adminer` values('11','1','admin','3','18712345678','03350785268','0','0');");
E_D("replace into `ecs_store_adminer` values('3','1','admin','2','18712345678','03350785268','0','0');");
E_D("replace into `ecs_store_adminer` values('4','5','沈阳库主管','2','18712345678','03350785268','0','0');");
E_D("replace into `ecs_store_adminer` values('10','7','北京库库管','4','18612340987','033512345678','0','0');");
E_D("replace into `ecs_store_adminer` values('9','1','admin','4','18712345678','03350785268','0','0');");
E_D("replace into `ecs_store_adminer` values('7','1','admin','1','18712345678','03350785268','0','0');");
E_D("replace into `ecs_store_adminer` values('8','6','北京库主管','1','13712345678','03350785268','0','0');");
E_D("replace into `ecs_store_adminer` values('13','14','yonghu1','5','','','18','18');");
E_D("replace into `ecs_store_adminer` values('14','14','yonghu1','6','移动电话','固定电话','18','18');");
E_D("replace into `ecs_store_adminer` values('15','14','yonghu1','8','移动电话','固定电话','18','18');");
E_D("replace into `ecs_store_adminer` values('16','14','yonghu1','7','','','18','18');");
E_D("replace into `ecs_store_adminer` values('17','19','68ecshopyy','11','13898776765','','22','22');");
E_D("replace into `ecs_store_adminer` values('18','19','68ecshopyy','12','13898776765','固定电话','22','22');");
E_D("replace into `ecs_store_adminer` values('19','19','68ecshopyy','10','13898776765','','22','22');");
E_D("replace into `ecs_store_adminer` values('20','19','68ecshopyy','9','13898776765','','22','22');");

require("../../inc/footer.php");
?>